interview

Sql Alias

Manish Kumar 1383 18-Dec-2017

database sql server

Updated on 20-Sep-2020

Other

Message

18-Dec-2017

Sql Alias are use to rename a table or a column name temporarily by giving another name.

It mekes table or column name more readable.

An alias only exists for the duration of the query.

SELECT column_name AS alias_name

FROM table_name;

SELECT column_name(s)

FROM table_name AS alias_name;